UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'dQ9qtFGON9sBQLMtlwC2r762+bUFi4eI9SVczAyXVmI='
WHERE
key_id = '1a71545f710349d406ec0869d6585711896eec2a7e976f0da0dc28188061b9f1'
AND (
token = 'dQ9qtFGON9sBQLMtlwC2r762+bUFi4eI9SVczAyXVmI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)