UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'oU3y37kLnwd2HHCxjlsyL+g7hFarf4+ZgIveLwINgwI='
WHERE
key_id = 'de67a21ce64e80489b276b20d77928c4f5425c552c0ef42d0b1bfab006e7c506'
AND (
token = 'oU3y37kLnwd2HHCxjlsyL+g7hFarf4+ZgIveLwINgwI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)