UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xObViDpgtafiDDz4VzLH4xoQO9eTE7Noi9h7qsOG5K8='
WHERE
key_id = '5c1d54fc94de9c62359a98539282280e52980f1ac8d6b0838d572c7013dfecd1'
AND (
token = 'xObViDpgtafiDDz4VzLH4xoQO9eTE7Noi9h7qsOG5K8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)