UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'v/ThJvmbqzZHVUik9J1s48dRjVHF/0MbBaf1w5wZMBI='
WHERE
key_id = '9d5eeb55f0a6f902274406befbdc219ecccb790d71b88befeb81a3f227897597'
AND (
token = 'v/ThJvmbqzZHVUik9J1s48dRjVHF/0MbBaf1w5wZMBI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)