UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'P27roIqYpTUDxnrLvyzjUQ7oBA2TEL9sFRBtpRp95y8='
WHERE
key_id = '195e7d28fdb81d9b80f6f45bda707541c8b66740ae934d655f28984627117241'
AND (
token = 'P27roIqYpTUDxnrLvyzjUQ7oBA2TEL9sFRBtpRp95y8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)