UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0BLmoxlTiuDsj1vyeWhayK0V1z1Z1zRcTlZN7XYr+3o='
WHERE
key_id = '023fc049ff7a7d5423f611602092b0f62b298763d9fb31d9cc133b572ca50e99'
AND (
token = '0BLmoxlTiuDsj1vyeWhayK0V1z1Z1zRcTlZN7XYr+3o='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)