UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xA6V89iiRInk95ZjlpG89Jr4+4LZgw3BGhpb/AuqKSA='
WHERE
key_id = '30e0ad41379814d3feac10498a6a0e13b0a2e100db27b141c90e886346fa6acf'
AND (
token = 'xA6V89iiRInk95ZjlpG89Jr4+4LZgw3BGhpb/AuqKSA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)