UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4ZkHWf0VzCNJsUgNSnR7bstF4Hy6/h40TxEpv9tfj8w='
WHERE
key_id = '1b0312d9113b4397b6d8669e178b1f27bbaac910329ff097e505be5e2c94ed5e'
AND (
token = '4ZkHWf0VzCNJsUgNSnR7bstF4Hy6/h40TxEpv9tfj8w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)