UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nV3IWug+bfbswZ5V4mHuZLDlFrJupR8mBJndxOdKTIE='
WHERE
key_id = '9fdf829984c759c37fa47dc5f22eac5f5b6287a6b845215d5eb10996fee56f99'
AND (
token = 'nV3IWug+bfbswZ5V4mHuZLDlFrJupR8mBJndxOdKTIE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)