UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gbMDTY2hfmWGN0eiyXyHXlSai+BrTNih7F49P5oghUA='
WHERE
key_id = '0e6b542f0ba59dde69bd63bbc27ee772bffaa03892cfa8be5e4bccfdf9be240a'
AND (
token = 'gbMDTY2hfmWGN0eiyXyHXlSai+BrTNih7F49P5oghUA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)