UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'jfAc2HCWOuYcSWPzryYoERPH67DZbmUJhMita8bn5vw='
WHERE
key_id = '2de2d4777a04041363f644b943f3fd1827ab8b47fae48a1abfe82d4af9fbc1ef'
AND (
token = 'jfAc2HCWOuYcSWPzryYoERPH67DZbmUJhMita8bn5vw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)