UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0eA93HAvrVxpquqenXLRKs8PSgwLF1ac1VnrGTRm1a4='
WHERE
key_id = '3fc8f94ceeb5b4d16a78de478e8d90795aaf513da7e4d6719ab057b665b2aa05'
AND (
token = '0eA93HAvrVxpquqenXLRKs8PSgwLF1ac1VnrGTRm1a4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)