UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'I4Hlxz4/ORzNQkRpjyFr8IOk6/gjAu1Nlx5zTSo9aKA='
WHERE
key_id = '3be149234c7c0f649ca895a9da048580e4785c46b5abbd651a2a3e4b95c5fb61'
AND (
token = 'I4Hlxz4/ORzNQkRpjyFr8IOk6/gjAu1Nlx5zTSo9aKA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)