UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'uifoD2C6B7OOO82Gns7h601rlZCi7cGT4DAZ0e1wDsM='
WHERE
key_id = 'a8020c8d05771074c84629d57298e772de4c15c6cd699adfdd9e97b852f2c039'
AND (
token = 'uifoD2C6B7OOO82Gns7h601rlZCi7cGT4DAZ0e1wDsM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)