UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8MoiAAtjCSSVCWZQePniUREz+zbdX3K3J79Fc23Epfc='
WHERE
key_id = '774e7d785cfcde41edff128d48390a9ff7448ac29c4739a963dc0201add117bd'
AND (
token = '8MoiAAtjCSSVCWZQePniUREz+zbdX3K3J79Fc23Epfc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)