UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'TxC5u7etzNrTgUzs+h9ZUpmdDh5y24ezePfp+IXWGaw='
WHERE
key_id = 'f0164eed9717ee0cc337e0381c054e9e0bd78d904131dce7eb5d6c4bea765ee8'
AND (
token = 'TxC5u7etzNrTgUzs+h9ZUpmdDh5y24ezePfp+IXWGaw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)