UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VimAT+XuYl42MLlepXkm2GzomSh/EsCrZkorrvMQ2Jw='
WHERE
key_id = '77cf0944c291c70e2f634851ec472b2bb0d060a33f0be7f3214c656e572cfebd'
AND (
token = 'VimAT+XuYl42MLlepXkm2GzomSh/EsCrZkorrvMQ2Jw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)