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