UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'JBgRR5XIGJcpk/BkZIUCcDw71oLpgFQ8INyd9M2mu78='
WHERE
key_id = '046978768990716aa0ddc33c908be03c566e8b7f92dfe5b20967c08fa98df3e0'
AND (
token = 'JBgRR5XIGJcpk/BkZIUCcDw71oLpgFQ8INyd9M2mu78='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)