UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'i47vebUNyK8wbTP7e7xqNr09LMPMfHIgjbJC/IJwWlk='
WHERE
key_id = '3d5e3dfb1b34e99cfb472d1e0b9078740556c1cd6b9e843538537ceab36f6b7d'
AND (
token = 'i47vebUNyK8wbTP7e7xqNr09LMPMfHIgjbJC/IJwWlk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)