UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gZNsKa/dzpsdWUk9Ou9NXgD34w/YgyF4kxeVVIDM64E='
WHERE
key_id = 'c87d2f6376783c0277ed029e0ac683809b890850dc3235ff1f757d4d5953da84'
AND (
token = 'gZNsKa/dzpsdWUk9Ou9NXgD34w/YgyF4kxeVVIDM64E='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)