UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2gHYDXUZck0B4VLOfGSgftddu9/AXttWV4B4VxWw2/0='
WHERE
key_id = '267dce8986f81eee556f0e5aa6cb075275d4e75fece621c6d9aae875e995a650'
AND (
token = '2gHYDXUZck0B4VLOfGSgftddu9/AXttWV4B4VxWw2/0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)