UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8fnPlRwdSRuME8zkGwtZPykw3UMXWFtUUy+wSsHB9J0='
WHERE
key_id = 'ff5dbe0123dc55bf442ea1946a235e9076e5f411f85ea119868ee2a777d78953'
AND (
token = '8fnPlRwdSRuME8zkGwtZPykw3UMXWFtUUy+wSsHB9J0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)