UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/rZ6j11ZNexzzVUDA1ajy4knN35vfzWBI/BlpcR4MJI='
WHERE
key_id = '21af1a88e0a6a5583504962c0f394da13e8d4d50deda9e2e4b06327144678690'
AND (
token = '/rZ6j11ZNexzzVUDA1ajy4knN35vfzWBI/BlpcR4MJI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)