UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hQ7iA1zHP7ABQ896SR+//OJ9wd1bjUi/9JeJmXsqE38='
WHERE
key_id = '4dd1754a4808fb785ebab16506b058066741b35d0763d508e43df199bc78aa55'
AND (
token = 'hQ7iA1zHP7ABQ896SR+//OJ9wd1bjUi/9JeJmXsqE38='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)