UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'RwR846LSycjJG6BZrKyJ0dheD+ILi6yauZvTfwcpAw4='
WHERE
key_id = '19c72d6a93c2e1becf1177e35115f8b04e0b1427499a1b3196ffd3ca4b9853eb'
AND (
token = 'RwR846LSycjJG6BZrKyJ0dheD+ILi6yauZvTfwcpAw4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)