UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4b0cnR6ydvxx6OFCdtNMSfDrjr/X9jezrn3lE5t3H1U='
WHERE
key_id = '36c88dfb345a3aace4061eead3172c019e17c73a4054e61a618c08ed87734e8a'
AND (
token = '4b0cnR6ydvxx6OFCdtNMSfDrjr/X9jezrn3lE5t3H1U='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)