UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8U9cPqbA5e40u1+M2PzXp/h4Q8AZVkjbbCmyDLsH36M='
WHERE
key_id = 'a270d54bb0c4c6091913692f9c8ba22d4114a054a034d1a3c3300910d89b68eb'
AND (
token = '8U9cPqbA5e40u1+M2PzXp/h4Q8AZVkjbbCmyDLsH36M='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)