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