UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'fM+ZXkQYo4t/KcioNLkd3prMV2gBloSPA1CvDj6sBI4='
WHERE
key_id = 'bd45525ed9702b960f3d29e1ca1bb91fa648058ce47c18dffa9a197260651ccd'
AND (
token = 'fM+ZXkQYo4t/KcioNLkd3prMV2gBloSPA1CvDj6sBI4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)