UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3JCNNkiAcei8BAIBYBBBSspCFmQKrftPUB6Z9y3ujXM='
WHERE
key_id = '79a38a8450508ddecbfbf749712665f7d0e72cc06cc9676a5e2fd1f68ced8fee'
AND (
token = '3JCNNkiAcei8BAIBYBBBSspCFmQKrftPUB6Z9y3ujXM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)