UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ad0VDbZ4iT5qcb+/tZdvPJinLIvV6QVjmpSxkwRabzU='
WHERE
key_id = 'eda0ad627488168bf693df2a42afd8170067f43e36aa3a38d7fca912625474c9'
AND (
token = 'ad0VDbZ4iT5qcb+/tZdvPJinLIvV6QVjmpSxkwRabzU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)