UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BZSkPeChlgfsBE7HmjQmc/SE9QRuCZctbU8l/BFtVVE='
WHERE
key_id = 'ad12a6b5b9677f825df2c7ce1278b2c2df05306ea3853356a4f0afe3266f5f92'
AND (
token = 'BZSkPeChlgfsBE7HmjQmc/SE9QRuCZctbU8l/BFtVVE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)