UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'n8DZGSDoipq8fqCWNl1KK+aezfJA2LqNn5eL5JWAvic='
WHERE
key_id = '478c16fdce35fa598585757124b37314f854dedf2fcf39b97536d26c0adb47b3'
AND (
token = 'n8DZGSDoipq8fqCWNl1KK+aezfJA2LqNn5eL5JWAvic='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)