UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6xx8MyK7+N/JcRE4pcHHk0lr0RDcnQKKOnxVd9KGERs='
WHERE
key_id = '268d5e9b6977513d0dd167322986bb71788f3fde1a227a728fb2eef08aae2275'
AND (
token = '6xx8MyK7+N/JcRE4pcHHk0lr0RDcnQKKOnxVd9KGERs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)